Interactive Lessons

Quickly filter your data to remove or isolate rows that fit your criteria.

Arrange data values in ascending or descending order with a Sort tool.

Why connect to one sheet four times when you can connect to four sheets at one time?

Creating relationships across a number of sheets can be time-consuming, to say the least. Save time. Take this lesson.

Splitting values into multiple columns or rows doesn’t have to be a pain. The Text to Columns tool makes it almost too easy.

Learn how to pivot your data between rows and columns! 

Need to create a subset of your data?  The Sample tool can help with that!

Identify the unique data values in your dataset

But what does it all mean? Summarize your data quickly and easily to derive meaning from large amounts of information.

Output your data to a variety of file types once you’ve finished processing your data.